Skip to main content
Version: 2.8

1 Introduction​

SQL Utils ...

1.1 SQL Utils with EVL Tool​

SQL Utils without any other EVL utils contain these scripts:

  • evd2sql – generate ‘create table’ statement from given EVD file (EVL data type definition),
  • sql2evl – generate EVL job(s) based on SQL(s).

TBA

1.2 SQL Utils with EVL Tool and other EVL utils​

In join with EVL Tool and other EVL utils, like EVL Avro Utils or EVL Parquet Utils or EVL Data Hub, you can also read/write by SQL:

  • various file formats: Avro, json, Parquet, QVD, xlsx, and xml,
  • various database tables: MySQL, PostgreSQL, Oracle, SQLite, Teradata, or any other by ODBC.

So it can be used for example in such an architecture with transformations defined as SQL:

TBA